UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'By/R7PM0kpHtXrpw/gw/91xR1q5+141iCk5HjMYDsC4='
WHERE
key_id = '1749f208d0aeb7a4ff59c9470abbf726e369820c9088ca77186b393ce71da40f'
AND (
token = 'By/R7PM0kpHtXrpw/gw/91xR1q5+141iCk5HjMYDsC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)