UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f7HlRUmtA3UMawUWugjZatmrvJ0U3IM4R7Zk5J3wYNY='
WHERE
key_id = 'd4d6b423c4f13b17a10ccbb865f163f371ef44d4941c5006b65fcec1dbd365ad'
AND (
token = 'f7HlRUmtA3UMawUWugjZatmrvJ0U3IM4R7Zk5J3wYNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)