UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHhaVmgniRXXYuNnhI4E+BdLacHWXGAlKddrYiQeonU='
WHERE
key_id = '38a7e8595f4c10a49241bba0c6d4d35aafd3c0ec548e1da2b15e66720a7bb8fc'
AND (
token = 'JHhaVmgniRXXYuNnhI4E+BdLacHWXGAlKddrYiQeonU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)