UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgPpo7/QqiuS49z0Fmq6S7w91t05ulUEvMZhHSw6clY='
WHERE
key_id = '381c88092393ea8b3e4629ec78780dc46adb0f02cf0fed155a9dc42475a79001'
AND (
token = 'BgPpo7/QqiuS49z0Fmq6S7w91t05ulUEvMZhHSw6clY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)