UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3OnhC58m++X7RYle2lNgUGpQg7XPTyihUwOy23afG0='
WHERE
key_id = 'cff9c374ed6896c4935cf3c9846ef6a5ed10eda1ac0d84befe37ce070a91c176'
AND (
token = 'B3OnhC58m++X7RYle2lNgUGpQg7XPTyihUwOy23afG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)