UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wbz02G8MiQgL+3MWA82dsqP99eOG6/KHUT0xYqcShYw=' 
WHERE 
  key_id = '634389a9b0046ab3d7c474eed5941bacd8e4f0e27c16acc61f70f9f6b95e83cf' 
  AND (
    token = 'wbz02G8MiQgL+3MWA82dsqP99eOG6/KHUT0xYqcShYw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047