UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnYlz8cctnnuaHj4ccwMCIEpOyeoE82Xu8IzofNBqCE='
WHERE
key_id = '23d3175528e8f4faa79e9df94ea13913298dc15aad9a28bf5d05425f51c64eeb'
AND (
token = 'JnYlz8cctnnuaHj4ccwMCIEpOyeoE82Xu8IzofNBqCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)