UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s2vd6EWkMdz1/mJPhPWodbSWLp7RmREW7MEeZaETac='
WHERE
key_id = '3cafa8778a60b6a097a2bb6f1772c8fc5df7fbcc821a15f65930ad5057294027'
AND (
token = '9s2vd6EWkMdz1/mJPhPWodbSWLp7RmREW7MEeZaETac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)