UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCuJYuIXNkB3CXusknKatN166IuYciWFr+rF4nTweBw='
WHERE
key_id = 'df96c763b6054705c182790e33e40acff942ed8b7ae87e34351829c21e71bacd'
AND (
token = 'HCuJYuIXNkB3CXusknKatN166IuYciWFr+rF4nTweBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)