UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBE3wP2CueHiaMVo6aWS+wPffwdVCg9pTmZOmuy55X4='
WHERE
key_id = '7180ce00a2eb4cc3d454ef869bec70bba74dcfbc59b282eabb87c84740f92453'
AND (
token = 'CBE3wP2CueHiaMVo6aWS+wPffwdVCg9pTmZOmuy55X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)