UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1CdhhAkKBv0sBQxxKLT/xaEjL/zcy7P0nggsce4TVk='
WHERE
key_id = 'd697ef1feac9c082788b2d57032e41c6845d6c00ad7a0159f5769cc94d9db166'
AND (
token = 'q1CdhhAkKBv0sBQxxKLT/xaEjL/zcy7P0nggsce4TVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)