UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kkX6z1KmpSIgR3AuzdRh/az3gvfKPjXAGBdobjlzQA0='
WHERE
key_id = 'e0a63e1a10ef6ccda966fd5821339146346890290fd2007800b9f9f25e8cbf27'
AND (
token = 'kkX6z1KmpSIgR3AuzdRh/az3gvfKPjXAGBdobjlzQA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)