UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnnnZ/2V4F6z7bOwZyvB8nXsCKPQEVP6wVncHn9zlRI='
WHERE
key_id = '60bb19796d52b83b5027b72d607b2790154e6a1581cde02ab2080f8bdebc7ee4'
AND (
token = 'nnnnZ/2V4F6z7bOwZyvB8nXsCKPQEVP6wVncHn9zlRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)