UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DG6AFhvxdRc208SPe3S7sMdAatd+6GQRFA3Xjl1mwVA=' 
WHERE 
  key_id = '43db0bd8d3ef7229bd270e9de8b17f64f9ab1ff6947e7b14b45facb746d5d402' 
  AND (
    token = 'DG6AFhvxdRc208SPe3S7sMdAatd+6GQRFA3Xjl1mwVA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043