UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z3Z6JI6keyl4C8dMAeRzoaGDruEnaSoKb07t8pNrY+U='
WHERE
key_id = 'd0fad23bdb966fb87081fcd8c6799df124a045b5f27fd7b501ee38865ba40745'
AND (
token = 'Z3Z6JI6keyl4C8dMAeRzoaGDruEnaSoKb07t8pNrY+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)