UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mB5YRLroKh6STSFjCxV1tORkImhCnG8vgnGxgLVOxzc='
WHERE
key_id = '492e749304487e0d0e835e74fa43dce62077346640f1fb3c1c8e8109581fbf21'
AND (
token = 'mB5YRLroKh6STSFjCxV1tORkImhCnG8vgnGxgLVOxzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)