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