UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QUNZ6f4C50tx3uwqrYZTHgzCqlf2+gPl0TRRD9IlQtE=' 
WHERE 
  key_id = 'fcb17a1b6245fd221cedfb37f97f435b2473f34484573a378a0c8a4164b8a3be' 
  AND (
    token = 'QUNZ6f4C50tx3uwqrYZTHgzCqlf2+gPl0TRRD9IlQtE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023