UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BUGAgpl4bNTU3pbZIeoC1D+IjxWEAT0o4aA+s7zwWIE=' 
WHERE 
  key_id = 'd5bd1c61fe475da8212b6766816ec6ce541cd1b346b82c16c0390866905a010b' 
  AND (
    token = 'BUGAgpl4bNTU3pbZIeoC1D+IjxWEAT0o4aA+s7zwWIE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024