UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ZOEHMBF6nqVobcohtPpqOfXbhJrLIid18kVsvrX1D4='
WHERE
key_id = 'a6c47567826069868112db4e68ca88d0217b2477ba8862777d1b04cf6ea27411'
AND (
token = '+ZOEHMBF6nqVobcohtPpqOfXbhJrLIid18kVsvrX1D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)