UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxAk/ICLPt+ziD038rR4THt1POypFxsiBRm41ZpR4/Y='
WHERE
key_id = '678716176f2e0f46b71340e2fece7682cae8c874169b3d3dbe0361d1eb755e08'
AND (
token = 'mxAk/ICLPt+ziD038rR4THt1POypFxsiBRm41ZpR4/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)