UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MJYpMBL4K6kqlDykSrpsrj5c9AMurrfSI66ytJrh57c=' 
WHERE 
  key_id = 'c2f7c34469b1ae4edea53fa72c38cd9904fff88fb3a957f3a8fcffeeeaaba7d8' 
  AND (
    token = 'MJYpMBL4K6kqlDykSrpsrj5c9AMurrfSI66ytJrh57c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025