UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K47CP2Cpy225tv3UnNac9LvC4jd0fEPTMoB+wtJiscc='
WHERE
key_id = '4dbad195a5bcfe96925a1239e6e7dc973065602ca0bee0cf3d512bee16353f64'
AND (
token = 'K47CP2Cpy225tv3UnNac9LvC4jd0fEPTMoB+wtJiscc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)