UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IgpCDDxfwasxiemX+IoWA0kNvmsjPbFSpyghhptE+zk=' 
WHERE 
  key_id = '76058f30f42e237296d4f890478679197a7efbd7cd8247919af7094a368f4b69' 
  AND (
    token = 'IgpCDDxfwasxiemX+IoWA0kNvmsjPbFSpyghhptE+zk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028