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