UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'x8NkYgqj48TD0gZ1Q1yJIB2S4YHCxmSzseOFQ/10Wvs=' 
WHERE 
  key_id = '1eb3b5093272171ead3bfed8cea5c497a21f7b6e13a8dfa6e3cafdceb9a31aad' 
  AND (
    token = 'x8NkYgqj48TD0gZ1Q1yJIB2S4YHCxmSzseOFQ/10Wvs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030