UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6i8GspPkEMWfpISzglQymh+qylRVNGLRSAaz8xmrcBU='
WHERE
key_id = '948e8e4ff21cb802a8b682dd0b2750ed6821d06a0377477bb2e195b4f8da5316'
AND (
token = '6i8GspPkEMWfpISzglQymh+qylRVNGLRSAaz8xmrcBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)