UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lgv9FvWsW4R4iZ/Q+DLnZSkIlX3+5rmcq5fZJsac/jI=' 
WHERE 
  key_id = '0d2d0f58b9e9a01f0431d6b390eb9fc273bac2ff7293364cc20a859d3fc5af12' 
  AND (
    token = 'lgv9FvWsW4R4iZ/Q+DLnZSkIlX3+5rmcq5fZJsac/jI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043