UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4J0OUIXTf/zpXshqTMs3F+gjhwX5bGztYmkpBdIVxs='
WHERE
key_id = '35b3087caa50421ed182092b563ec84a248808e199cc1d05fd458ffadbd12738'
AND (
token = 'R4J0OUIXTf/zpXshqTMs3F+gjhwX5bGztYmkpBdIVxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)