UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pb45i6n9cOwQKOksRrBnfE9vJooKpGKAYRMV5zB7Ug='
WHERE
key_id = '8fdb445119e0401a154469ea38934cdadf584a28a47cced1cff874220e5abaaf'
AND (
token = '7pb45i6n9cOwQKOksRrBnfE9vJooKpGKAYRMV5zB7Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)