UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cC7VapxlfPDhL0RikatYpDproe4QVgJCRgGpZ5wQqcQ=' 
WHERE 
  key_id = '5acc37de9c7a67aacb728abeacf7c0d1429ec0ffe3a732ca1162d9de27ffb985' 
  AND (
    token = 'cC7VapxlfPDhL0RikatYpDproe4QVgJCRgGpZ5wQqcQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046