UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC0HqDaRs5Lh+5iBWkXMYqdwE6Cxr2dGGLDUFT60WVE='
WHERE
key_id = '0c255c9db294801f840b093df910128843b1a1f5513044d43741d502a8de2b4c'
AND (
token = 'ZC0HqDaRs5Lh+5iBWkXMYqdwE6Cxr2dGGLDUFT60WVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)