UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xe/0q+jvk1G162nwSBwIfJK0AD0hIYvjR5Kr1f75Z7U='
WHERE
key_id = 'a5531f8b1c483e54b25ac10b9547de0c970607e8908c3750f2a56a5123a3290f'
AND (
token = 'xe/0q+jvk1G162nwSBwIfJK0AD0hIYvjR5Kr1f75Z7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)