UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6P8lOluY0vcCcNEENfT4mHMmsfcj4pwfTS/OZ/Lxrbo='
WHERE
key_id = '300febf8ebc8b1a73c50026425c92f008637e74da7ab01785c6a21029585d2a4'
AND (
token = '6P8lOluY0vcCcNEENfT4mHMmsfcj4pwfTS/OZ/Lxrbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)