UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9eht+jMrl77wfZf9veEG+SbjyxNQeZUy+CKSYO5iTo='
WHERE
key_id = '6ee2501e44b6e27ce746ad0a3cb50e785d9d9baf08ddbde569850cae21b594a0'
AND (
token = 'L9eht+jMrl77wfZf9veEG+SbjyxNQeZUy+CKSYO5iTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)