UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OPE/4fa8c/J1cdi2iZsw+5alCskC48GKcoOaoxN+yLc='
WHERE
key_id = '76d6d253ce06cff3d81fb608eff34ae7635a489b1edbecb90be89da56160baa4'
AND (
token = 'OPE/4fa8c/J1cdi2iZsw+5alCskC48GKcoOaoxN+yLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)