UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iQ1DhdgMAduy6j7C+EXJySOIBPnC++nd84K/6s9uJ8='
WHERE
key_id = '4acd5e15a09281136414ad7cc959bfdfe8466fc289e1c78dd9ef316371b48f79'
AND (
token = '8iQ1DhdgMAduy6j7C+EXJySOIBPnC++nd84K/6s9uJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)