UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4oH62Wsn5czQQSr3dgKr27YJT2F3JTN64katg7cV4X4='
WHERE
key_id = 'ffa53ae5e88d9f2315d043d166f25a412e775ffeca637e6f01138cb8510c58c1'
AND (
token = '4oH62Wsn5czQQSr3dgKr27YJT2F3JTN64katg7cV4X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)