UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '99r8EPbc5Y4FKgjx62XtLJj3sEUlJJ32tz8lgM2jPVs=' 
WHERE 
  key_id = '1c5c8e5cd018e9fb5a2482f325f3b8adbb598e35cda5621ab3bcefd20b06584d' 
  AND (
    token = '99r8EPbc5Y4FKgjx62XtLJj3sEUlJJ32tz8lgM2jPVs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022