UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXOrWeHRpnSMBR+YY53NG3Sf0S2uQbpGhyE8RBgWK+c='
WHERE
key_id = '81378b5ff99c809d03236a4e7aee7690321d8d8d85aa3de3cb6341cfa86d518a'
AND (
token = 'fXOrWeHRpnSMBR+YY53NG3Sf0S2uQbpGhyE8RBgWK+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)