UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OYHwn65PSxg9LjQ+sxZYuMcJR28+a6CaP8b5jnb2PuQ=' 
WHERE 
  key_id = '29df3377e7c9ddebc1f68caeebc34c60899536f77f3eb35359e5925d4c940a0b' 
  AND (
    token = 'OYHwn65PSxg9LjQ+sxZYuMcJR28+a6CaP8b5jnb2PuQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049