UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTyjO2996lhpmG5kmmsUd1/w2oGdg8nshmB+W01mZhc='
WHERE
key_id = '8bc94b5962cf5043a18823161e372529b983bd31f0cccd051b347526c68cf5ae'
AND (
token = 'ZTyjO2996lhpmG5kmmsUd1/w2oGdg8nshmB+W01mZhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)