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